<%--
  Created by IntelliJ IDEA.
  User: Lenovo
  Date: 2018/5/3
  Time: 16:16
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
  <head>
    <title>$Title$</title>
  </head>
  <body>
 <jsp:include page="header.jsp"/>

 <style type="text/css">

     table{
         border-collapse: collapse;
     }
     td{
         border:  1px solid #000;
         padding:10px;

     }
 </style>


 <table>
     <tr>
         <td>编号</td>
         <td>用户名</td>
         <td>密码</td>
         <td>操作1</td>
         <td>操作2</td>
     </tr>
     <%
         //脚本
         //3+1 从数据库查数据;
         Connection connection=null;
         Statement statement=null;
         ResultSet resultSet=null;
         String sql="select*from t_users";
         //加载驱动程序
         Class.forName("com.mysql.jdbc.Driver");
         connection= DriverManager.getConnection("jdbc:mysql://localhost:3306/sctu_javaweb_2018?serverTimezone=UTC",
                 "root",
                 "413618"
         );
         statement=connection.createStatement();
         resultSet=statement.executeQuery(sql);

         class User{
             int id;
             String username;
             String password;

         }
         List<User> userList=new ArrayList<User>();
         while(resultSet.next()){
             int id=resultSet.getInt(1);
             String username=resultSet.getNString(2);
             String password=resultSet.getNString(3);

             User user=new User();
             user.id=id;
             user.username=username;
             user.password=password;
             userList.add(user);
         }
         resultSet.close();
         statement.close();
         connection.close();

         for(User u:userList){
             out.write("<tr><td>" + user.id +
                     "</td><td>" + user.name +
                     "</td><td>" + user.password +
                     "</td><td>" +
                     "<a href='deleteUserHandler.jsp?id="
                     +user.id+"'>删除</a></td>" +
                     "<td><a href='updateUser.jsp?id="+user.id+"&username="+user.name+"" +
                     "&password="+user.password+"'>更新</a></td></tr>"


             );

         }
     %>
     %>

     <tr>
         <td>1</td>
         <td>zhang</td>
         <td>413618</td>
         <td>更新</td>
         <td>删除</td>

     </tr>

 </table>























  </body>
</html>
